import pandas as pd

pd.set_option('display.unicode.east_asian_width', True)
df = pd.read_excel('学生成绩表.xlsx')
df['总成绩'] = df.sum(axis=1, numeric_only=True)
df['平均成绩'] = df.mean(axis=1, numeric_only=True)
print(df)
print(df.describe())
